home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Fritz: All Fritz
/
All Fritz.zip
/
All Fritz
/
FILES
/
SPREOTUS
/
SPEDCORS.LZH
/
L53
< prev
next >
Wrap
Text File
|
1992-06-06
|
6KB
|
199 lines
L53 ╔══════════════════════════════════╗
║ INTRODUCTION TO KEYBOARD MACROS ║
╚══════════════════════════════════╝
Macros Are Great Time Savers
Wouldn't it be nice if you could replace the 5 keystrokes
that it takes to change the width of a column with one keystroke.
It would be the same as having 5 pennies and replacing them
with a nickel.
√√√ A MACRO IS LIKE A NICKEL
It can replace 5 keystrokes with one keystroke.
A Macro is a collection of commands that is assigned to a key.
When that key is pressed the commands are automatically
executed, one at a time, until all commands are processed.
√√√ WE USE MACROS EVERY DAY
Macros are great time savers. For example, you want
to make a long distance call to New York (1-212-567 7890).
You dial one number and you get your party. This is an
example of a Macro. You dial one number, it in turn automatically
dials 11 numbers. The Phone people call this Speed dialing.
Macro is Speed dialing, where you use one or two keystroke, to
replace having to enter a number of different commands.
√√√ LOTUS HAS ITS OWN MACRO LANGUAGE
Lotus uses a special language for Macros.
Here are a few that you will be using to create Macros.
The Tilde symbol (~) (Pronounced Til da).
The Tilde symbol is located on the first key on the
first row of the keyboard.
This symbol is used in Macro formulas to indicate
the <Enter> key. This gives the Macro an automatic
carriage return, the same as pressing the <Enter> key.
√√√ THE "ALT" KEY IS CALLED THE MACRO KEY
It can be used in combination with the 26 letters of the alphabet.
√√√ WHEN WRITING A MACRO
Always start with ('/) (Apostrophe and forward slash).
And end with (~) (Tilde symbol).
Next is an example using R (Range) and E (Erase).
√√√ MACRO FORMULA FOR ERASING A CELL
'/RE~ (~ this is the Tilde symbol).
(This reads as...Apostrophe, Forward Slash, R E and Tilde).
√√√ TO CREATE A MACRO FOR ERASING A CELL
Move cursor to Cell A1 for practice.
Type '/RE~ Press <Enter> key.
The apostrophe (') does not appear in the cell
because it is a label prefix character.
√√√ TO NAME THE MACRO
Press (/) R N C (Range, Name. Create) press <Enter> key.
Enter name as \E Press <Enter> key.
For "Enter Range" type A1..A1. Press <Enter> key.
- 27 -
√√√ ERASING A CELL WITH THE ALT-E MACRO
Move cursor to C1.
Type your name. Press <Enter> key.
Press and hold down the Alt key.
Press E key. Contents (Label) in Cell C1 is erased.
√√√ MACRO FOR CURRENCY AND TWO DECIMAL PLACES
Macro formula '/RFC2~
(apostrophe, forward slash, Range, Format,
Column, Two decimal places, and ~ (press <Enter> key).
√√√ TO CREATE MACRO
Move cursor to Cell C1 for practice.
Type '/RFC2~ Press <Enter> key.
√√√ TO NAME MACRO
Press (/) R N C (Range, Name, Create)
Enter name \C Press <Enter> key.
For Enter Range (C1..C1) Press <Enter> key.
√√√ HOW TO USE
Move cursor to Cell D1, and type some numbers, like 34.6.
Press and hold down the Alt key and press the C key.
Release both keys.
Screen says Enter range to format: D1..D1
Since you have only one cell D1, press <Enter> key.
Numbers will have 2 decimal places and ($) sign.
√√√ HOW TO SAVE YOUR MACROS
Press (/) F S
File to save.
Type name of Macro (RFC2)
Press <Enter> key.
√√√ A MACRO FOR SAVING FILES
You can create a Macro that will automatically
do the above steps for you. Here's how the Macro is written.
To Start Macro:
Move cursor to Cell A2.
Type '/ F S
√√√ TO NAME MACRO
For name type '/ R N C
Press <Enter> key.
Type in name of Macro \S
Upper right of screen shows
Enter range. You press <Enter> key.
√√√ HOW TO USE THE MACRO "Save Files"
Press and hold down the <Alt> key.
Now press the S key. Release both keys.
If this is an old file,
Press <Enter> key, then R for replace.
If you have a new file,
Type in new name. Press <Enter> key.
- 28 -
√√√ WINDOWS
Windows allows you to look at two different parts of a
worksheet at the same time. This is good way to make comparison
from say one month to another. Or for any comparison of set of data
to another.
The Formula goes like this:
Move the cursor down about 10 rows.
Your screen will have a second heading at line 10.
You can move the cursor in any direction.
When you move cursor down it will continue to change rows while
the lower half of the window remains stationary.
To cross over to the other window Press the F6 function key
Now if you move the cursor upward it will change cells while the
upper window remains stationary.
√√√ TO RETURN TO ONE WORKSHEET
Use W W C (C for clear).
In the horizontal mode both windows move at the same time.
√√√ TO UNSYNC USE W W Unsync.
*** END OF CHAPTER ***
Press <Esc> key to return to Menu.
Select Pie Graph And Press <Enter> key.
- 29 -